• a5_finddupsgenie Function
• a5_get_recs_in_qry_local Function
• a5_paste_current_record Function
• a5_paste_from_clipboard Function
• a5_paste_new_record Function
• a5_put_rec_on_clipboard Function
• a5_rec_clip_has_data Function
• a5_records_undelete Function
• a5_remove_recs_genie Function
• a5_selected_records Function
• BOTTOM_PERCENT_RECORDS Function
• BOTTOM_RECORDS Function
• CHANGE_RECORD Method
• CURRENT_RECORD Function
• CURRENT_RECORD_NUMBER Function
• DBAVG Function
• DBCOUNT Function
• DBMAX Function
• DBMIN Function
• DBSUM Function
• DELETE_RECORD Method
• DELETED Function
• ENTER RECORD Method
• EVERY_RECORD_LIST Function
• FILTER_STRING Function
• form_qs_explicit Function
• IS_RECNO_IN Function
• LOOKUP Function
• LOOKUPC Function
• LOOKUPD Function
• LOOKUPL Function
• LOOKUPN Function
• MARKED Function
• page_records_get Function
• POP_STDDEV Function
• POP_VARIANCE Function
• RANDOM_PCT_RECORD_LIST Function
• RANDOM_PERCENT_RECORDS Function
• RANDOM_RECORD_LIST Function
• RANDOM_RECORDS Function
• RECORD_ADD Function
• RECORD_DELETE Function
• RECORD_UPDATE Function
• RUN_AVERAGE Function
• RUN_MAXIMUM Function
• RUN_MINIMUM Function
• RUN_STDDEV Function
• RUN_VARIANCE Function
• SAMPLE_RECORDS Function
• STDDEV Function
• TOP_PERCENT_RECORDS Function
• TOP_RECORDS Function
• TOP_RECORDS_LIST Function
• TOP_RECORDS_PCT_LIST Function
• VARIANCE Function

ENTER_RECORD Method

Syntax

Arguments

var

A dot variable with the field values from the specified table.

Description

Allows for data to be entered when using Xbasic with a Form or Browse. Returns a dot variable that is the validation object.

In this example the .enter_record() method returns a dot variable that contains information about any Field Rule violations that occured.

t = table.open("customer")
'DIM a dot variable with properties that match the fieldnames you want to enter
dim r as p
r.firstname = ""
r.company = "alpha"
 
DIM v as p
v = t.enter_record(r)
?v.has_errors
= .T.
?v.error.size()
= 2

?v.Format("$(field) = $(error)"+crlf())
= CUSTOMER1->COMPANY = company can't be alpha
CUSTOMER1->LASTNAME = Field is required: LASTNAME

In this example a dot variable is created with properties for all of the fields that you want to enter. We enter the 'firstname' and 'company' fields in the customer table. Once the dot variable has been created, the <Tbl>.enter_record() method is called. This method takes as its argument the dot variable with the field values.

This method return a dot variable. The dot variable has an 'has_errors' property which lets you know if the method succeeded or not. If not, then the errors are returned in an array called 'errors' which is a sub-property of the dot variable. The dot variable that is returned by the .enter_record() method is actually an object (the 'validation' object), and it has a .Format() method, which allows you to format the error message into a friendly text or html format ready for display to the user. The format() method can use these placeholders:

$(field)

Placeholder for the fieldname for which the error occurred

$(error)

Placeholder for the plain-text error message

$(errorhtml)

Placeholder for the HTML formatted error message

In the above example, the .Format() method is called with this argument:

"$(field) = $(error)"+crlf()

The crlf() function is necessary because the .Format() method does not put in line breaks between each message. The string "$(field) = $(error)" contains two placeholders which get replaced by each field for which an error occurred and by the corresponding error message.

See Also

• CHANGE_RECORD Method
• DELETE_RECORD Method
• Field Rules Honored During Xbasic Data Entry